/*
 Navicat Premium Data Transfer

 Source Server         : 内网数据库
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : 192.168.1.179:3307
 Source Schema         : pdl_sit

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 18/02/2022 17:35:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for bank_error
-- ----------------------------
DROP TABLE IF EXISTS `bank_error`;
CREATE TABLE `bank_error` (
                              `id` int(10) NOT NULL AUTO_INCREMENT,
                              `remark` varchar(255) DEFAULT NULL COMMENT '错误信息',
                              `trans_status` varchar(255) DEFAULT NULL COMMENT '错误状态',
                              `notes` varchar(255) DEFAULT NULL,
                              `prompt` varchar(255) DEFAULT NULL COMMENT '用户提示',
                              `operation_guide` varchar(255) DEFAULT NULL COMMENT '操作指南',
                              `status` int(10) DEFAULT '0' COMMENT '状态',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bank_error
-- ----------------------------
BEGIN;
INSERT INTO `bank_error` VALUES (1, 'Insufficient funds', '0', '余额不足', 'Card balance insufficient; please ensure above 50 Naira balance and try again', NULL, 0);
INSERT INTO `bank_error` VALUES (2, 'A server error has occurred. Please try again', '0', '发生服务器错误。请再试一次', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (3, 'An OTP related error has occured, please contact support', '0', '出现OTP相关错误，请联系技术支持', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (4, 'either remote server cannot be reached or network connection was reset/broken', '0', '远程服务器无法连接或网络连接被重置/断开', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (19, 'Card validation failed. Error occured while processing your request', '0', '信用卡验证失败。处理您的请求时发生错误', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (20, 'Enter the OTP code sent to your phone to complete the transaction', '0', '输入发送到您手机的OTP代码来完成交易', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (21, 'Error occured while enrolling you for OTP!', '0', '注册OTP时发生错误!', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (22, 'Error occured while processing your request!', '0', '处理您的请求时发生错误!', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (23, 'Error occured.', '0', '错误发生。', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (24, 'Error Occurred. Could Not Generate Token', '0', '错误发生。无法生成令牌', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (25, 'Error, please try again.', '0', '错误，请重试。', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (26, 'No response', '0', '没有响应', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (27, 'Not processed', '0', '未处理', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (28, 'Suspected Malfunction', '0', '疑似故障', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (29, 'System Error', '0', '系统错误', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (30, 'System Malfunction', '0', '系统故障', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (31, 'Timed Out', '0', '超时', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (32, 'TimeOut calling postilion service', '0', '超时', 'Third-party network error, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (33, 'Exceeds withdrawal frequency limit', '0', '超过提款限额', 'Bank card withdrawal exceeds the limit; please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (34, 'Exceeds withdrawal frequency', '0', '超过提款频率', 'Bank card withdrawal exceeds the limit; please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (35, 'Exceeds withdrawal frequency', '0', '超过取款频率限制', 'Bank card withdrawal exceeds the limit; please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (36, 'Exceeds Withdrawal Limit', '0', '超过取款限额', 'Bank card withdrawal exceeds the limit; please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (37, 'Expired card', '0', '过期的信用卡', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (38, 'Information not on file', '0', '未存档的资料', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (39, 'Invalid card number', '0', '无效的卡号', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (40, 'Invalid Digital Signature', '0', '无效的数字签名', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (41, 'invalid token supplied', '0', '	提供无效的令牌', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (42, 'Invalid Transaction', '0', '无效交易', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (43, 'Issuer or Switch Inoperative', '0', '卡失效', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (44, 'Lost card', '0', '挂失卡', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (45, 'Lost Card, Pick-Up', '0', '挂失卡', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (46, 'Merchant is not enabled for international transactions.', '0', '商户不允许进行国际交易', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (47, 'No Card Record', '0', '没有卡记录', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (48, 'No Check Account', '0', '没有支票帐户', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (49, 'No cheque account', '0', '没有支票帐户', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (50, 'No Hardware, No SMS sent', '0', '没有硬件，没有短信发送', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (51, 'Payment Requires Token', '0', '付款需要令牌', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (52, 'Pickup card (lost card)', '0', '挂失卡（丢失）', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (53, 'Pickup card (stolen card)', '0', '挂失卡（被盗）', 'Bank card invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (54, 'PIN tries exceeded', '0', 'PIN输入次数超限制', 'The number of PIN entries exceeded the limit. Please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (55, 'PIN Tries Exceeded, Pick-Up', '0', 'PIN输入次数超限制', 'The number of PIN entries exceeded the limit. Please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (56, 'Allowable number of PIN tries exceeded', '0', '允许的PIN尝试次数超过', 'The number of PIN entries exceeded the limit. Please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (57, 'Please enter otp sent to your phone', '0', '请输入otp发送到您的手机', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (58, 'Please enter the OTP you received, or the one generated by your hardware token', '0', '请输入您收到的OTP，或您的硬件令牌生成的OTP', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (59, 'Press the white button on your GTB token and type the transaction code generated', '0', '按下GTB令牌上的白色按钮，并键入生成的交易代码', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (60, 'Kindly enter the mobile no registered with your bank', '0', '请输入银行卡未注册号码', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (61, 'ncorrect PIN', '0', 'PIN错误', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (62, 'The transaction was not completed', '0', '交易没有完成', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (63, 'Transaction not Found', '0', '交易未找到', 'Card binding not completed, please try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (64, 'Received invalid response from remote entity', '0', '从远程实体收到无效响应', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (65, 'Restricted card', '0', '限制卡', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (66, 'Restricted Card, Pick-Up', '0', '限制卡', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (67, 'Security violation', '0', '违反安全', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (68, 'Stolen card, pick up', '0', '被盗卡，拾起', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (69, 'Stolen Card, Pick-UpStolen Card, Pick-Up', '0', '被盗卡', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (70, 'Suspected Fraud', '0', '疑似欺诈行为', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (71, 'Suspected Fraud, Pick-Up', '0', '被盗卡，拾起', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (72, 'Suspected Fraud, Pick-Up', '0', '疑似欺诈行为，拾起', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (73, 'The card holder was not authorised. This is used in 3-D Secure Authentication.', '0', '持卡人未获授权。这在3-D安全认证中使用。', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (74, 'Token Authentication Failed. Incorrect Token Supplied.', '0', '令牌的身份验证失败。提供不正确的令牌。', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (75, 'Token Authorization Not Successful. Incorrect Token Supplied', '0', '令牌授权不成功。提供不正确的令牌', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (76, 'Token Not Generated. Customer Not Registered on Token Platform', '0', '不会生成令牌。客户未在令牌平台上注册', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (77, 'Transaction not permitted to card holder', '0', '持卡人不得进行交易', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (78, 'Transaction was blocked by the Payment Server because it did not pass all risk checks', '0', '支付服务器阻止了交易，因为它没有通过所有的风险检查。', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (79, 'Unable to retrieve customer details', '0', '无法检索客户详细信息', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (80, 'Unspecified Failure', '0', '未指明的失败', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (81, 'Your account does not seem to have a phone number, email or hardware token provisioned. Please contact your account officer', '0', '您的帐户似乎没有电话号码，电子邮件或硬件令牌供应。请联系您的帐户主管', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (82, 'Blocked by fraud system', '0', '被欺诈系统屏蔽', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (83, 'Card brand is blacklisted for local transactions', '0', '信用卡品牌被列入本地交易黑名单', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (84, 'Declined by Financial institution', '0', '金融机构拒绝', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (85, 'Denied by Fraud System', '0', '被欺诈系统拒绝', 'Bank card  invalid, please change the card and try again', 'Try again with different card', 0);
INSERT INTO `bank_error` VALUES (86, 'Received invalid response from remote entity', '0', '你的付款已经超过了支付的时间', 'Bank card  invalid, please change the card and try again', 'Try again', 0);
INSERT INTO `bank_error` VALUES (87, NULL, '5', NULL, 'Bank card exist', NULL, NULL);
INSERT INTO `bank_error` VALUES (88, NULL, '7', NULL, 'Bank card exist', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
